SET SERVEROUTPUT ON

--Displaying AUDSID,USERNAME,STATUS for the current login user on the basis of the current session id for the current user.
SELECT SID,USERNAME,STATUS
	FROM v$session
	WHERE AUDSID=sys_context('USERENV','SESSIONID');
	